Advanced Excel 2021

Name: Advanced Excel 2021
Availability: InStock

Become an expert at using the key functions and features of MS Excel 2021 with this free online course on Alison.com.

Published by

Saved For Later

Confident you have the skills to certify without completing the course content?

Learning Outcomes

In this free course, you will learn how to:

Examine the key behaviours known as ‘arrays’ and ‘spills’ and how to properly apply them in MS Excel 2021
Identify the key differences between unique and distinct values along with their usage with multiple criteria and columns
Describe the role of the SORT function and how to apply it in the proper manner
Explain how to use the SORTBY function in Excel, particularly the horizontal Sort aspect
Examine the use of the SEQUENCE function and how to unstack records from the source data
Describe the use of the FILTER function in Excel 2021 along with various logic aspects
Explain the use of RANDARRAY and RANDBETWEEN functions in Excel 2021 and how they can be applied to randomize data
Describe the application of two-way LOOKUPS, XLOOKUP and XMATCH functions to perform complex lookups
Identify the difference between the CHOOSE and SWITCH functions to sort out source data
Examine the use of statistical functions such as means, median and mode in Excel 2021 to perform calculations
Explain h

Published by

Positive learner ratings

Learners Courses

Earn credentials that matter: Anyone can say they’re learning. A CPD-accredited Alison Certificate proves you followed through.
Get an edge over others: Add your Certificate to your CV, LinkedIn, and Alison Profile to strengthen job applications and promotion opportunities.
Show you’re serious about growth: A Certificate signals initiative, commitment, and a willingness to keep learning; qualities employers actively look for.